PREVIEW / etf_30min / 2011-03-14

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-03-14.parquet
  size:    282 KB
  rows:    9,384

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-03-14 04:00:00	SPY	ETF	130.5	131.25	129.95	129.96	45021.0
2011-03-14 04:30:00	SPY	ETF	130.06	130.28	129.89	130.26	36475.0
2011-03-14 05:00:00	SPY	ETF	130.26	130.68	130.26	130.54	7150.0
2011-03-14 05:30:00	SPY	ETF	130.62	130.72	130.55	130.56	11708.0
2011-03-14 06:00:00	SPY	ETF	130.7	130.8	130.66	130.66	1200.0
2011-03-14 06:30:00	SPY	ETF	130.63	130.66	130.45	130.49	128879.0
2011-03-14 07:00:00	SPY	ETF	130.56	130.63	130.15	130.3	522214.0
2011-03-14 07:30:00	SPY	ETF	130.29	130.54	130.05	130.14	1143644.0
2011-03-14 08:00:00	SPY	ETF	130.15	130.61	129.98	130.12	3577965.0
2011-03-14 08:30:00	SPY	ETF	130.12	130.31	130.0149	130.21	2082065.0
2011-03-14 09:00:00	SPY	ETF	130.22	130.24	129.92	129.99	1535362.0
2011-03-14 09:30:00	SPY	ETF	129.99	130.45	129.94	130.28	24700950.0
2011-03-14 10:00:00	SPY	ETF	130.29	130.48	129.98	130.1	13748858.0
2011-03-14 10:30:00	SPY	ETF	130.1	130.11	129.46	129.62	20670277.0
2011-03-14 11:00:00	SPY	ETF	129.61	129.83	129.21	129.26	18815910.0
2011-03-14 11:30:00	SPY	ETF	129.27	129.47	129.12	129.319	14821552.0
2011-03-14 12:00:00	SPY	ETF	129.32	129.43	129.16	129.26	7830210.0
2011-03-14 12:30:00	SPY	ETF	129.26	129.38	129.06	129.37	8977984.0
2011-03-14 13:00:00	SPY	ETF	129.37	129.58	129.33	129.45	8654899.0
2011-03-14 13:30:00	SPY	ETF	129.44	129.63	129.26	129.47	7963162.0
2011-03-14 14:00:00	SPY	ETF	129.48	129.94	129.46	129.87	13254783.0
2011-03-14 14:30:00	SPY	ETF	129.87	129.88	129.45	129.54	8222093.0
2011-03-14 15:00:00	SPY	ETF	129.54	129.98	129.48	129.79	12953459.0
2011-03-14 15:30:00	SPY	ETF	129.79	130.3	129.35	130.07	28645843.0
2011-03-14 16:00:00	SPY	ETF	130.07	130.8862	129.24	129.98	17353370.0
2011-03-14 16:30:00	SPY	ETF	129.98	130.8862	129.6628	130.06	11630820.0
2011-03-14 17:00:00	SPY	ETF	130.06	130.09	130.03	130.05	2173147.0
2011-03-14 17:30:00	SPY	ETF	130.05	130.09	130.02	130.06	24800.0
2011-03-14 18:00:00	SPY	ETF	130.06	130.25	130.05	130.18	218013.0
2011-03-14 18:30:00	SPY	ETF	130.16	130.18	130.06	130.06	28678.0
2011-03-14 19:00:00	SPY	ETF	130.14	130.17	129.77	129.8	94366.0
2011-03-14 19:30:00	SPY	ETF	129.81	129.81	129.33	129.56	331135.0
2011-03-14 04:00:00	QQQ	ETF	56.22	56.22	56.22	56.22	100.0
2011-03-14 04:30:00	QQQ	ETF	56.04	56.09	56.0	56.09	4200.0
2011-03-14 05:30:00	QQQ	ETF	56.34	56.34	56.25	56.25	2100.0
2011-03-14 06:00:00	QQQ	ETF	56.34	56.38	56.34	56.38	350.0
2011-03-14 06:30:00	QQQ	ETF	56.31	56.31	56.2	56.2	3208.0
2011-03-14 07:00:00	QQQ	ETF	56.28	56.29	56.11	56.17	81300.0
2011-03-14 07:30:00	QQQ	ETF	56.16	56.26	56.09	56.15	447311.0
2011-03-14 08:00:00	QQQ	ETF	56.16	56.22	56.13	56.17	1286625.0
2011-03-14 08:30:00	QQQ	ETF	56.2	56.3	56.16	56.23	201590.0
2011-03-14 09:00:00	QQQ	ETF	56.23	56.25	56.14	56.17	390787.0
2011-03-14 09:30:00	QQQ	ETF	56.18	56.59	56.14	56.5399	8316487.0
2011-03-14 10:00:00	QQQ	ETF	56.54	56.59	56.24	56.28	5883140.0
2011-03-14 10:30:00	QQQ	ETF	56.29	56.32	56.06	56.06	9321632.0
2011-03-14 11:00:00	QQQ	ETF	56.07	56.195	55.91	55.95	6704666.0
2011-03-14 11:30:00	QQQ	ETF	55.96	56.04	55.9	55.95	5606737.0
2011-03-14 12:00:00	QQQ	ETF	55.9598	56.02	55.89	55.945	2496070.0
2011-03-14 12:30:00	QQQ	ETF	55.94	56.04	55.86	56.0398	2865622.0
2011-03-14 13:00:00	QQQ	ETF	56.03	56.15	56.02	56.0701	3353167.0

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

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