PREVIEW / etf_30min / 2015-05-01

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-05-01.parquet
  size:    377 KB
  rows:    12,563

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-05-01 04:00:00	SPY	ETF	209.0	209.0	208.89	208.9	25100.0
2015-05-01 04:30:00	SPY	ETF	209.0	209.01	209.0	209.01	800.0
2015-05-01 05:00:00	SPY	ETF	209.01	209.03	209.01	209.03	275.0
2015-05-01 05:30:00	SPY	ETF	209.05	209.09	209.02	209.07	6925.0
2015-05-01 06:00:00	SPY	ETF	209.05	209.12	209.05	209.11	16151.0
2015-05-01 06:30:00	SPY	ETF	209.11	209.15	209.02	209.02	100150.0
2015-05-01 07:00:00	SPY	ETF	209.05	209.27	208.99	209.27	114841.0
2015-05-01 07:30:00	SPY	ETF	209.27	209.37	209.19	209.2	326823.0
2015-05-01 08:00:00	SPY	ETF	209.16	209.33	209.05	209.16	666104.0
2015-05-01 08:30:00	SPY	ETF	209.18	209.2	209.09	209.18	196482.0
2015-05-01 09:00:00	SPY	ETF	209.18	209.54	208.52	209.42	976945.0
2015-05-01 09:30:00	SPY	ETF	209.4	209.88	209.37	209.5399	13243259.0
2015-05-01 10:00:00	SPY	ETF	209.52	210.1	209.42	209.8367	8301852.0
2015-05-01 10:30:00	SPY	ETF	209.84	209.96	209.35	209.6	6310082.0
2015-05-01 11:00:00	SPY	ETF	209.61	210.0	209.6	209.99	3874328.0
2015-05-01 11:30:00	SPY	ETF	210.0	210.1	209.28	209.6	5520118.0
2015-05-01 12:00:00	SPY	ETF	209.6	209.74	209.34	209.74	3494230.0
2015-05-01 12:30:00	SPY	ETF	209.74	209.945	209.69	209.94	3243784.0
2015-05-01 13:00:00	SPY	ETF	209.94	210.0	209.785	209.91	2438562.0
2015-05-01 13:30:00	SPY	ETF	209.92	210.49	209.855	210.38	8462427.0
2015-05-01 14:00:00	SPY	ETF	210.37	210.71	210.34	210.695	5997761.0
2015-05-01 14:30:00	SPY	ETF	210.7	210.72	210.36	210.44	5165323.0
2015-05-01 15:00:00	SPY	ETF	210.45	210.53	210.21	210.279	6443833.0
2015-05-01 15:30:00	SPY	ETF	210.279	210.77	210.26	210.69	14022264.0
2015-05-01 16:00:00	SPY	ETF	210.69	210.73	209.99	210.7	6478043.0
2015-05-01 16:30:00	SPY	ETF	210.71	210.74	210.65	210.71	6120477.0
2015-05-01 17:00:00	SPY	ETF	210.7199	210.77	210.61	210.62	419875.0
2015-05-01 17:30:00	SPY	ETF	210.611	210.65	210.611	210.65	30105.0
2015-05-01 18:00:00	SPY	ETF	210.67	210.75	210.66	210.71	85539.0
2015-05-01 18:30:00	SPY	ETF	210.69	210.72	210.68	210.72	8350.0
2015-05-01 19:00:00	SPY	ETF	210.68	210.7	210.68	210.69	7200.0
2015-05-01 19:30:00	SPY	ETF	210.69	210.7	210.681	210.7	11455.0
2015-05-01 04:00:00	QQQ	ETF	107.71	107.71	107.71	107.71	400.0
2015-05-01 06:00:00	QQQ	ETF	107.75	107.75	107.75	107.75	5000.0
2015-05-01 06:30:00	QQQ	ETF	107.86	107.86	107.79	107.79	3600.0
2015-05-01 07:00:00	QQQ	ETF	107.78	107.92	107.78	107.92	103310.0
2015-05-01 07:30:00	QQQ	ETF	107.94	107.96	107.88	107.88	26300.0
2015-05-01 08:00:00	QQQ	ETF	107.88	107.9	107.82	107.85	50857.0
2015-05-01 08:30:00	QQQ	ETF	107.86	107.87	107.75	107.84	28602.0
2015-05-01 09:00:00	QQQ	ETF	107.84	108.11	107.63	108.05	176039.0
2015-05-01 09:30:00	QQQ	ETF	108.05	108.51	108.03	108.24	5401253.0
2015-05-01 10:00:00	QQQ	ETF	108.22	108.68	108.2	108.54	2834587.0
2015-05-01 10:30:00	QQQ	ETF	108.55	108.61	108.2	108.37	1739239.0
2015-05-01 11:00:00	QQQ	ETF	108.37	108.54	108.325	108.54	1253632.0
2015-05-01 11:30:00	QQQ	ETF	108.55	108.62	108.14	108.29	1458570.0
2015-05-01 12:00:00	QQQ	ETF	108.3	108.37	108.17	108.37	1114715.0
2015-05-01 12:30:00	QQQ	ETF	108.38	108.555	108.36	108.55	1205849.0
2015-05-01 13:00:00	QQQ	ETF	108.54	108.55	108.42	108.48	841343.0
2015-05-01 13:30:00	QQQ	ETF	108.49	108.86	108.465	108.79	1708291.0
2015-05-01 14:00:00	QQQ	ETF	108.78	109.05	108.7757	109.04	1968533.0

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

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