PREVIEW / etf_30min / 2011-10-03

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-10-03.parquet
  size:    306 KB
  rows:    10,425

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
2011-10-03 04:00:00	SPY	ETF	112.25	112.92	112.25	112.89	10315.0
2011-10-03 04:30:00	SPY	ETF	112.89	112.92	112.64	112.65	6417.0
2011-10-03 05:00:00	SPY	ETF	112.49	112.84	112.47	112.84	4900.0
2011-10-03 05:30:00	SPY	ETF	112.87	112.87	112.56	112.56	53798.0
2011-10-03 06:00:00	SPY	ETF	112.46	113.05	112.46	113.03	39430.0
2011-10-03 06:30:00	SPY	ETF	112.99	113.19	112.84	113.0	61726.0
2011-10-03 07:00:00	SPY	ETF	112.99	113.05	112.7	112.83	698479.0
2011-10-03 07:30:00	SPY	ETF	112.81	113.1	112.74	113.07	382760.0
2011-10-03 08:00:00	SPY	ETF	112.95	113.27	112.01	112.55	1879331.0
2011-10-03 08:30:00	SPY	ETF	112.54	112.65	112.37	112.41	820044.0
2011-10-03 09:00:00	SPY	ETF	112.41	113.17	112.3	112.46	2189349.0
2011-10-03 09:30:00	SPY	ETF	112.49	112.94	112.08	112.19	25839401.0
2011-10-03 10:00:00	SPY	ETF	112.2	113.95	112.08	113.17	41529500.0
2011-10-03 10:30:00	SPY	ETF	113.17	113.255	112.1	112.415	23483580.0
2011-10-03 11:00:00	SPY	ETF	112.43	113.06	112.1	112.87	18370555.0
2011-10-03 11:30:00	SPY	ETF	112.87	113.2	112.55	113.07	19957636.0
2011-10-03 12:00:00	SPY	ETF	113.06	113.17	112.1799	112.25	13915045.0
2011-10-03 12:30:00	SPY	ETF	112.25	112.27	111.66	111.72	15224654.0
2011-10-03 13:00:00	SPY	ETF	111.72	111.73	110.85	111.23	23104815.0
2011-10-03 13:30:00	SPY	ETF	111.23	111.32	110.4	110.91	24166442.0
2011-10-03 14:00:00	SPY	ETF	110.91	111.33	110.64	110.79	24516393.0
2011-10-03 14:30:00	SPY	ETF	110.79	111.0	110.16	110.71	21667631.0
2011-10-03 15:00:00	SPY	ETF	110.71	111.22	110.26	110.35	30066767.0
2011-10-03 15:30:00	SPY	ETF	110.36	111.27	109.81	109.92	49396102.0
2011-10-03 16:00:00	SPY	ETF	109.88	113.1304	109.16	109.34	22160191.0
2011-10-03 16:30:00	SPY	ETF	109.34	109.83	109.24	109.25	2436889.0
2011-10-03 17:00:00	SPY	ETF	109.26	109.28	109.02	109.12	539514.0
2011-10-03 17:30:00	SPY	ETF	109.2	109.28	109.08	109.27	222845.0
2011-10-03 18:00:00	SPY	ETF	109.25	109.93	109.15	109.32	349496.0
2011-10-03 18:30:00	SPY	ETF	109.33	109.42	109.18	109.42	85275.0
2011-10-03 19:00:00	SPY	ETF	109.41	109.43	109.2	109.25	97075.0
2011-10-03 19:30:00	SPY	ETF	109.2	109.37	109.1	109.32	263634.0
2011-10-03 04:00:00	QQQ	ETF	52.05	52.08	52.05	52.08	2052.0
2011-10-03 05:00:00	QQQ	ETF	52.22	52.22	52.1	52.1	869.0
2011-10-03 05:30:00	QQQ	ETF	52.21	52.21	52.15	52.15	11000.0
2011-10-03 06:30:00	QQQ	ETF	52.34	52.35	52.27	52.27	25500.0
2011-10-03 07:00:00	QQQ	ETF	52.24	52.29	52.15	52.18	40510.0
2011-10-03 07:30:00	QQQ	ETF	52.2	52.28	52.12	52.25	109648.0
2011-10-03 08:00:00	QQQ	ETF	52.25	52.37	52.03	52.05	236292.0
2011-10-03 08:30:00	QQQ	ETF	52.07	52.13	51.98	52.01	249725.0
2011-10-03 09:00:00	QQQ	ETF	52.01	52.49	51.97	52.04	591584.0
2011-10-03 09:30:00	QQQ	ETF	52.04	52.36	51.8	51.901	9289564.0
2011-10-03 10:00:00	QQQ	ETF	51.87	52.85	51.82	52.5	11046126.0
2011-10-03 10:30:00	QQQ	ETF	52.5	52.55	52.08	52.13	6576531.0
2011-10-03 11:00:00	QQQ	ETF	52.13	52.52	52.02	52.38	5642885.0
2011-10-03 11:30:00	QQQ	ETF	52.39	52.54	52.18	52.43	3039709.0
2011-10-03 12:00:00	QQQ	ETF	52.44	52.48	52.1	52.17	4037123.0
2011-10-03 12:30:00	QQQ	ETF	52.16	52.17	51.79	51.85	4698609.0
2011-10-03 13:00:00	QQQ	ETF	51.85	51.85	51.51	51.71	5576301.0
2011-10-03 13:30:00	QQQ	ETF	51.7199	51.77	51.32	51.58	5119608.0

> showing 50 of 10,425 rows — these rows as CSV

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