PREVIEW / etf_30min / 2018-04-02

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-04-02.parquet
  size:    492 KB
  rows:    16,943

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2018-04-02 04:00:00	SPY	ETF	262.68	263.0	262.68	263.0	9186.0
2018-04-02 04:30:00	SPY	ETF	262.91	262.91	262.77	262.77	218.0
2018-04-02 05:00:00	SPY	ETF	262.74	262.91	262.73	262.86	4927.0
2018-04-02 05:30:00	SPY	ETF	262.83	262.92	262.83	262.92	1180.0
2018-04-02 06:00:00	SPY	ETF	262.94	263.1	262.94	263.03	6145.0
2018-04-02 06:30:00	SPY	ETF	263.0	263.1	262.92	263.0	6560.0
2018-04-02 07:00:00	SPY	ETF	262.8	262.83	262.4	262.44	76795.0
2018-04-02 07:30:00	SPY	ETF	262.4	262.45	262.19	262.4	108540.0
2018-04-02 08:00:00	SPY	ETF	262.46	263.23	262.31	262.48	213059.0
2018-04-02 08:30:00	SPY	ETF	262.48	263.15	262.42	262.8	311444.0
2018-04-02 09:00:00	SPY	ETF	262.78	262.81	262.46	262.6	340626.0
2018-04-02 09:30:00	SPY	ETF	262.55	263.13	261.49	261.77	8717627.0
2018-04-02 10:00:00	SPY	ETF	261.74	261.85	260.49	260.67	7425687.0
2018-04-02 10:30:00	SPY	ETF	260.67	260.68	259.34	259.4	6273580.0
2018-04-02 11:00:00	SPY	ETF	259.41	259.42	258.36	259.15	9626131.0
2018-04-02 11:30:00	SPY	ETF	259.14	259.16	256.63	257.37	16612746.0
2018-04-02 12:00:00	SPY	ETF	257.38	257.52	256.32	257.3	9995527.0
2018-04-02 12:30:00	SPY	ETF	257.27	258.27	257.23	257.52	8126600.0
2018-04-02 13:00:00	SPY	ETF	257.52	257.84	256.04	256.12	7347631.0
2018-04-02 13:30:00	SPY	ETF	256.121	256.88	255.4	255.4015	9888335.0
2018-04-02 14:00:00	SPY	ETF	255.4	256.25	254.67	255.45	12393302.0
2018-04-02 14:30:00	SPY	ETF	255.46	256.33	254.9	256.16	14466093.0
2018-04-02 15:00:00	SPY	ETF	256.15	256.9	255.68	255.98	14471246.0
2018-04-02 15:30:00	SPY	ETF	255.97	258.03	255.5	257.53	29263376.0
2018-04-02 16:00:00	SPY	ETF	257.51	257.62	256.89	257.14	22788679.0
2018-04-02 16:30:00	SPY	ETF	257.12	257.85	257.12	257.85	4135869.0
2018-04-02 17:00:00	SPY	ETF	257.66	257.88	255.6003	257.65	269529.0
2018-04-02 17:30:00	SPY	ETF	257.64	257.66	257.39	257.62	177790.0
2018-04-02 18:00:00	SPY	ETF	257.62	257.87	256.99	257.8	816056.0
2018-04-02 18:30:00	SPY	ETF	257.82	257.89	257.36	257.46	180386.0
2018-04-02 19:00:00	SPY	ETF	257.46	257.58	257.33	257.46	53949.0
2018-04-02 19:30:00	SPY	ETF	257.47	257.87	257.46	257.87	54197.0
2018-04-02 04:00:00	QQQ	ETF	159.2	159.3	159.19	159.3	4763.0
2018-04-02 04:30:00	QQQ	ETF	159.35	159.35	159.25	159.3	1327.0
2018-04-02 05:00:00	QQQ	ETF	159.16	159.36	159.13	159.33	9530.0
2018-04-02 05:30:00	QQQ	ETF	159.28	159.33	159.28	159.33	2100.0
2018-04-02 06:00:00	QQQ	ETF	159.37	159.56	159.37	159.44	44530.0
2018-04-02 06:30:00	QQQ	ETF	159.49	159.5	159.31	159.31	13524.0
2018-04-02 07:00:00	QQQ	ETF	159.27	159.27	158.76	158.81	72833.0
2018-04-02 07:30:00	QQQ	ETF	158.87	158.95	158.66	158.9	34859.0
2018-04-02 08:00:00	QQQ	ETF	158.81	159.16	158.72	158.97	142851.0
2018-04-02 08:30:00	QQQ	ETF	158.96	160.13	158.96	159.2	86937.0
2018-04-02 09:00:00	QQQ	ETF	159.21	159.3	158.92	158.98	229684.0
2018-04-02 09:30:00	QQQ	ETF	159.0	159.74	157.93	158.2	5726077.0
2018-04-02 10:00:00	QQQ	ETF	158.19	158.2286	157.26	157.36	4129386.0
2018-04-02 10:30:00	QQQ	ETF	157.36	157.57	156.68	156.75	4758160.0
2018-04-02 11:00:00	QQQ	ETF	156.75	156.79	155.92	156.68	5765570.0
2018-04-02 11:30:00	QQQ	ETF	156.67	156.68	154.81	155.45	6607481.0
2018-04-02 12:00:00	QQQ	ETF	155.42	156.0054	154.97	155.84	4177319.0
2018-04-02 12:30:00	QQQ	ETF	155.829	156.62	155.8	156.01	2751968.0

> showing 50 of 16,943 rows — these rows as CSV

> unlock the full archive -- $79 one-time