PREVIEW / etf_30min / 2015-02-23

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-02-23.parquet
  size:    374 KB
  rows:    12,750

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
2015-02-23 04:00:00	SPY	ETF	211.0	211.0	210.8	210.8	4520.0
2015-02-23 05:00:00	SPY	ETF	210.7	210.8	210.7	210.8	3400.0
2015-02-23 05:30:00	SPY	ETF	210.75	210.8	210.74	210.8	2400.0
2015-02-23 06:00:00	SPY	ETF	210.79	210.79	210.71	210.71	7357.0
2015-02-23 06:30:00	SPY	ETF	210.66	210.8	210.65	210.77	142516.0
2015-02-23 07:00:00	SPY	ETF	210.77	210.83	210.66	210.74	140557.0
2015-02-23 07:30:00	SPY	ETF	210.75	210.92	210.74	210.85	168253.0
2015-02-23 08:00:00	SPY	ETF	210.85	210.87	210.75	210.81	152327.0
2015-02-23 08:30:00	SPY	ETF	210.79	210.9	210.74	210.81	296321.0
2015-02-23 09:00:00	SPY	ETF	210.82	211.0	210.75	210.93	631965.0
2015-02-23 09:30:00	SPY	ETF	210.94	210.99	210.48	210.76	8164599.0
2015-02-23 10:00:00	SPY	ETF	210.76	210.85	210.51	210.74	5287661.0
2015-02-23 10:30:00	SPY	ETF	210.74	210.94	210.7	210.875	4746059.0
2015-02-23 11:00:00	SPY	ETF	210.88	211.06	210.84	211.045	3594147.0
2015-02-23 11:30:00	SPY	ETF	211.04	211.11	210.99	211.02	2663923.0
2015-02-23 12:00:00	SPY	ETF	211.02	211.08	210.84	210.85	2455247.0
2015-02-23 12:30:00	SPY	ETF	210.84	210.95	210.65	210.8	4464781.0
2015-02-23 13:00:00	SPY	ETF	210.8	210.89	210.72	210.8	1600243.0
2015-02-23 13:30:00	SPY	ETF	210.8068	211.09	210.8	210.895	4070514.0
2015-02-23 14:00:00	SPY	ETF	210.895	211.04	210.88	211.015	3652203.0
2015-02-23 14:30:00	SPY	ETF	211.01	211.01	210.67	210.75	4625445.0
2015-02-23 15:00:00	SPY	ETF	210.75	210.77	210.53	210.74	3717425.0
2015-02-23 15:30:00	SPY	ETF	210.731	211.21	210.725	211.21	9930102.0
2015-02-23 16:00:00	SPY	ETF	211.21	211.31	210.72	211.18	3558562.0
2015-02-23 16:30:00	SPY	ETF	211.18	211.256	211.14	211.16	480904.0
2015-02-23 17:00:00	SPY	ETF	211.18	211.18	211.13	211.14	51984.0
2015-02-23 17:30:00	SPY	ETF	211.16	211.16	211.13	211.16	28545.0
2015-02-23 18:00:00	SPY	ETF	211.16	211.18	211.09	211.1	63607.0
2015-02-23 18:30:00	SPY	ETF	211.1	211.1	211.09	211.09	52798.0
2015-02-23 19:00:00	SPY	ETF	211.09	211.1	211.07	211.1	9825.0
2015-02-23 19:30:00	SPY	ETF	211.12	211.14	211.09	211.12	16480.0
2015-02-23 04:00:00	QQQ	ETF	108.41	108.41	108.41	108.41	100.0
2015-02-23 04:30:00	QQQ	ETF	108.21	108.21	108.21	108.21	1000.0
2015-02-23 06:30:00	QQQ	ETF	108.27	108.32	108.27	108.31	1500.0
2015-02-23 07:00:00	QQQ	ETF	108.3	108.31	108.29	108.29	6650.0
2015-02-23 07:30:00	QQQ	ETF	108.33	108.35	108.32	108.35	2210.0
2015-02-23 08:00:00	QQQ	ETF	108.3	108.36	108.3	108.341	22163.0
2015-02-23 08:30:00	QQQ	ETF	108.34	108.36	108.3	108.32	36309.0
2015-02-23 09:00:00	QQQ	ETF	108.32	108.4	108.3	108.35	89078.0
2015-02-23 09:30:00	QQQ	ETF	108.35	108.46	108.22	108.352	2351618.0
2015-02-23 10:00:00	QQQ	ETF	108.36	108.3899	108.11	108.165	2402251.0
2015-02-23 10:30:00	QQQ	ETF	108.17	108.39	108.165	108.27	1872375.0
2015-02-23 11:00:00	QQQ	ETF	108.28	108.41	108.265	108.4	1023499.0
2015-02-23 11:30:00	QQQ	ETF	108.4	108.44	108.355	108.38	699229.0
2015-02-23 12:00:00	QQQ	ETF	108.38	108.45	108.33	108.3801	567098.0
2015-02-23 12:30:00	QQQ	ETF	108.38	108.41	108.25	108.3572	530895.0
2015-02-23 13:00:00	QQQ	ETF	108.36	108.41	108.3	108.36	387839.0
2015-02-23 13:30:00	QQQ	ETF	108.36	108.43	108.32	108.3599	796034.0
2015-02-23 14:00:00	QQQ	ETF	108.36	108.48	108.36	108.46	690405.0
2015-02-23 14:30:00	QQQ	ETF	108.46	108.46	108.32	108.3201	806423.0

> showing 50 of 12,750 rows — these rows as CSV

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