PREVIEW / etf_30min / 2014-01-08

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-01-08.parquet
  size:    341 KB
  rows:    11,479

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
2014-01-08 04:00:00	SPY	ETF	183.51	183.51	183.41	183.41	1790.0
2014-01-08 04:30:00	SPY	ETF	183.32	183.32	183.31	183.31	200.0
2014-01-08 05:00:00	SPY	ETF	183.22	183.26	183.22	183.24	1422.0
2014-01-08 05:30:00	SPY	ETF	183.13	183.14	183.09	183.14	5600.0
2014-01-08 06:00:00	SPY	ETF	183.22	183.27	183.22	183.23	1733.0
2014-01-08 06:30:00	SPY	ETF	183.2	183.23	183.11	183.13	23154.0
2014-01-08 07:00:00	SPY	ETF	183.13	183.23	183.12	183.2	34771.0
2014-01-08 07:30:00	SPY	ETF	183.22	183.31	183.22	183.26	84950.0
2014-01-08 08:00:00	SPY	ETF	183.21	183.6	183.05	183.09	608958.0
2014-01-08 08:30:00	SPY	ETF	183.08	183.42	183.08	183.3	631308.0
2014-01-08 09:00:00	SPY	ETF	183.29	183.46	183.25	183.45	463988.0
2014-01-08 09:30:00	SPY	ETF	183.45	183.58	182.89	183.24	10007350.0
2014-01-08 10:00:00	SPY	ETF	183.24	183.75	183.111	183.67	10582218.0
2014-01-08 10:30:00	SPY	ETF	183.67	183.83	183.54	183.58	6183905.0
2014-01-08 11:00:00	SPY	ETF	183.59	183.6525	183.37	183.45	5931385.0
2014-01-08 11:30:00	SPY	ETF	183.45	183.77	183.44	183.7	3486248.0
2014-01-08 12:00:00	SPY	ETF	183.705	183.769	183.54	183.56	1956282.0
2014-01-08 12:30:00	SPY	ETF	183.55	183.61	183.42	183.48	3725055.0
2014-01-08 13:00:00	SPY	ETF	183.48	183.65	183.34	183.48	3803084.0
2014-01-08 13:30:00	SPY	ETF	183.485	183.65	183.43	183.58	3254481.0
2014-01-08 14:00:00	SPY	ETF	183.58	183.73	183.23	183.41	12572469.0
2014-01-08 14:30:00	SPY	ETF	183.41	183.5732	183.28	183.38	3790546.0
2014-01-08 15:00:00	SPY	ETF	183.38	183.47	182.979	183.02	6014753.0
2014-01-08 15:30:00	SPY	ETF	183.02	183.6	182.97	183.53	15734533.0
2014-01-08 16:00:00	SPY	ETF	183.54	183.68	183.46	183.55	4200440.0
2014-01-08 16:30:00	SPY	ETF	183.55	183.6	183.41	183.57	2506681.0
2014-01-08 17:00:00	SPY	ETF	183.56	183.65	183.56	183.59	77708.0
2014-01-08 17:30:00	SPY	ETF	183.55	183.6	183.55	183.55	19220.0
2014-01-08 18:00:00	SPY	ETF	183.55	183.55	183.5	183.54	39825.0
2014-01-08 18:30:00	SPY	ETF	183.51	183.55	183.5	183.5	9465.0
2014-01-08 19:00:00	SPY	ETF	183.5	183.53	183.49	183.49	21620.0
2014-01-08 19:30:00	SPY	ETF	183.52	183.54	183.5	183.52	17060.0
2014-01-08 04:00:00	QQQ	ETF	87.04	87.04	87.04	87.04	3000.0
2014-01-08 05:30:00	QQQ	ETF	86.93	86.97	86.93	86.97	900.0
2014-01-08 07:00:00	QQQ	ETF	86.94	87.01	86.94	87.0	5100.0
2014-01-08 07:30:00	QQQ	ETF	87.02	87.04	87.02	87.03	1600.0
2014-01-08 08:00:00	QQQ	ETF	87.03	87.15	86.97	86.98	137977.0
2014-01-08 08:30:00	QQQ	ETF	86.98	87.12	86.98	87.08	44570.0
2014-01-08 09:00:00	QQQ	ETF	87.04	87.13	87.04	87.12	237099.0
2014-01-08 09:30:00	QQQ	ETF	87.11	87.2	86.945	87.1799	3370189.0
2014-01-08 10:00:00	QQQ	ETF	87.1799	87.429	87.12	87.4	2058926.0
2014-01-08 10:30:00	QQQ	ETF	87.41	87.55	87.331	87.3499	1437926.0
2014-01-08 11:00:00	QQQ	ETF	87.35	87.43	87.3	87.35	835150.0
2014-01-08 11:30:00	QQQ	ETF	87.36	87.52	87.36	87.4975	783204.0
2014-01-08 12:00:00	QQQ	ETF	87.5	87.53	87.4	87.41	512414.0
2014-01-08 12:30:00	QQQ	ETF	87.41	87.42	87.35	87.38	770674.0
2014-01-08 13:00:00	QQQ	ETF	87.39	87.46	87.311	87.39	733114.0
2014-01-08 13:30:00	QQQ	ETF	87.4	87.46	87.36	87.4199	926950.0
2014-01-08 14:00:00	QQQ	ETF	87.418	87.51	87.29	87.4	2574982.0
2014-01-08 14:30:00	QQQ	ETF	87.4	87.459	87.3	87.33	1236653.0

> showing 50 of 11,479 rows — these rows as CSV

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