PREVIEW / etf_30min / 2011-11-03

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-11-03.parquet
  size:    291 KB
  rows:    9,639

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-11-03 04:00:00	SPY	ETF	122.5	122.88	122.25	122.77	2650.0
2011-11-03 04:30:00	SPY	ETF	122.67	123.13	122.6	123.13	3969.0
2011-11-03 05:00:00	SPY	ETF	123.2	123.75	123.14	123.47	20270.0
2011-11-03 05:30:00	SPY	ETF	123.55	124.27	123.35	123.95	31501.0
2011-11-03 06:00:00	SPY	ETF	123.95	124.87	123.95	124.44	46448.0
2011-11-03 06:30:00	SPY	ETF	124.46	124.57	124.06	124.38	129334.0
2011-11-03 07:00:00	SPY	ETF	124.42	124.65	123.98	124.52	887320.0
2011-11-03 07:30:00	SPY	ETF	124.52	124.72	124.23	124.43	851982.0
2011-11-03 08:00:00	SPY	ETF	123.07	125.06	122.23	124.92	5564541.0
2011-11-03 08:30:00	SPY	ETF	124.92	126.0	124.79	125.73	9355866.0
2011-11-03 09:00:00	SPY	ETF	125.71	125.76	123.9513	125.25	6081881.0
2011-11-03 09:30:00	SPY	ETF	125.27	125.42	124.16	124.38	29744875.0
2011-11-03 10:00:00	SPY	ETF	124.38	124.57	123.595	124.38	34968978.0
2011-11-03 10:30:00	SPY	ETF	124.38	125.14	124.3	124.68	27492467.0
2011-11-03 11:00:00	SPY	ETF	124.68	125.28	124.52	125.19	14571759.0
2011-11-03 11:30:00	SPY	ETF	125.19	125.33	124.87	124.91	10965580.0
2011-11-03 12:00:00	SPY	ETF	124.91	125.31	124.83	125.25	10605581.0
2011-11-03 12:30:00	SPY	ETF	125.25	125.59	124.89	125.51	12506299.0
2011-11-03 13:00:00	SPY	ETF	125.51	125.83	125.37	125.58	9699422.0
2011-11-03 13:30:00	SPY	ETF	125.58	126.21	125.5	125.85	14450131.0
2011-11-03 14:00:00	SPY	ETF	125.86	126.16	125.73	125.78	18362574.0
2011-11-03 14:30:00	SPY	ETF	125.79	125.98	125.63	125.82	10907006.0
2011-11-03 15:00:00	SPY	ETF	125.825	126.26	125.8	126.215	14394835.0
2011-11-03 15:30:00	SPY	ETF	126.22	126.5	126.03	126.26	32099230.0
2011-11-03 16:00:00	SPY	ETF	126.25	126.2943	126.05	126.09	14689312.0
2011-11-03 16:30:00	SPY	ETF	126.1	126.24	126.01	126.07	4979352.0
2011-11-03 17:00:00	SPY	ETF	126.07	126.23	126.06	126.17	189239.0
2011-11-03 17:30:00	SPY	ETF	126.14	126.17	126.07	126.14	135381.0
2011-11-03 18:00:00	SPY	ETF	126.12	126.24	126.09	126.17	431783.0
2011-11-03 18:30:00	SPY	ETF	126.18	126.275	125.96	126.08	4625743.0
2011-11-03 19:00:00	SPY	ETF	126.09	126.14	125.99	126.09	21687.0
2011-11-03 19:30:00	SPY	ETF	126.11	126.18	126.09	126.1	56118.0
2011-11-03 04:00:00	QQQ	ETF	56.3	56.3	56.12	56.12	11142.0
2011-11-03 04:30:00	QQQ	ETF	56.28	56.32	56.28	56.32	642.0
2011-11-03 05:00:00	QQQ	ETF	56.59	56.66	56.59	56.66	600.0
2011-11-03 05:30:00	QQQ	ETF	56.55	56.86	56.55	56.86	1900.0
2011-11-03 06:00:00	QQQ	ETF	56.96	57.18	56.95	57.0	6253.0
2011-11-03 06:30:00	QQQ	ETF	57.01	57.04	56.9	57.04	3400.0
2011-11-03 07:00:00	QQQ	ETF	57.06	57.08	56.8	57.0	962922.0
2011-11-03 07:30:00	QQQ	ETF	57.04	57.11	56.94	57.05	130774.0
2011-11-03 08:00:00	QQQ	ETF	57.01	57.19	57.0	57.14	2792581.0
2011-11-03 08:30:00	QQQ	ETF	57.14	57.43	57.04	57.37	4011164.0
2011-11-03 09:00:00	QQQ	ETF	57.35	57.4	57.21	57.34	1432403.0
2011-11-03 09:30:00	QQQ	ETF	57.34	57.43	56.95	57.02	7378668.0
2011-11-03 10:00:00	QQQ	ETF	57.03	57.12	56.71	57.05	8287480.0
2011-11-03 10:30:00	QQQ	ETF	57.06	57.47	57.03	57.26	6184128.0
2011-11-03 11:00:00	QQQ	ETF	57.26	57.65	57.24	57.6	3255367.0
2011-11-03 11:30:00	QQQ	ETF	57.6	57.68	57.4	57.42	3566070.0
2011-11-03 12:00:00	QQQ	ETF	57.41	57.59	57.33	57.57	3528440.0
2011-11-03 12:30:00	QQQ	ETF	57.57	57.69	57.4	57.64	2277757.0

> showing 50 of 9,639 rows — these rows as CSV

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