PREVIEW / etf_30min / 2010-06-08

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-06-08.parquet
  size:    261 KB
  rows:    8,619

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
2010-06-08 04:00:00	SPY	ETF	106.25	106.25	105.89	105.89	2278.0
2010-06-08 04:30:00	SPY	ETF	105.81	105.81	105.4	105.43	1788.0
2010-06-08 05:00:00	SPY	ETF	105.33	105.41	105.15	105.31	30300.0
2010-06-08 05:30:00	SPY	ETF	105.2	105.35	105.11	105.18	5100.0
2010-06-08 06:00:00	SPY	ETF	105.25	105.61	105.25	105.55	8628.0
2010-06-08 06:30:00	SPY	ETF	105.6	105.7	105.32	105.41	63712.0
2010-06-08 07:00:00	SPY	ETF	105.4	105.77	105.4	105.67	209368.0
2010-06-08 07:30:00	SPY	ETF	105.66	105.8	105.56	105.64	337054.0
2010-06-08 08:00:00	SPY	ETF	105.67	105.98	105.64	105.89	985891.0
2010-06-08 08:30:00	SPY	ETF	105.9	105.96	105.63	105.74	1459181.0
2010-06-08 09:00:00	SPY	ETF	105.75	105.89	105.54	105.57	1199743.0
2010-06-08 09:30:00	SPY	ETF	105.57	106.13	105.16	105.359	34434085.0
2010-06-08 10:00:00	SPY	ETF	105.35	105.9	105.1	105.48	32434504.0
2010-06-08 10:30:00	SPY	ETF	105.48	105.58	104.68	105.23	30939540.0
2010-06-08 11:00:00	SPY	ETF	105.225	105.78	104.65	105.5099	36324784.0
2010-06-08 11:30:00	SPY	ETF	105.5	106.32	105.05	106.06	27400218.0
2010-06-08 12:00:00	SPY	ETF	106.06	106.21	105.62	105.695	14069065.0
2010-06-08 12:30:00	SPY	ETF	105.695	106.1	105.66	106.05	10702659.0
2010-06-08 13:00:00	SPY	ETF	106.04	106.14	105.5	105.82	12584553.0
2010-06-08 13:30:00	SPY	ETF	105.555	105.62	104.83	105.22	22820431.0
2010-06-08 14:00:00	SPY	ETF	105.2228	105.88	104.98	105.68	20970341.0
2010-06-08 14:30:00	SPY	ETF	105.68	106.16	105.54	105.601	23947206.0
2010-06-08 15:00:00	SPY	ETF	105.62	106.19	105.36	106.18	24036937.0
2010-06-08 15:30:00	SPY	ETF	106.19	106.83	105.55	106.57	44326409.0
2010-06-08 16:00:00	SPY	ETF	106.57	106.66	104.96	106.46	9215349.0
2010-06-08 16:30:00	SPY	ETF	106.45	106.56	105.72	106.54	6661538.0
2010-06-08 17:00:00	SPY	ETF	106.56	106.6	106.52	106.55	206415.0
2010-06-08 17:30:00	SPY	ETF	106.56	106.57	105.14	106.55	70397.0
2010-06-08 18:00:00	SPY	ETF	106.55	106.57	106.44	106.53	89471.0
2010-06-08 18:30:00	SPY	ETF	106.55	106.57	106.5	106.56	41451.0
2010-06-08 19:00:00	SPY	ETF	106.56	106.63	106.49	106.6	23453.0
2010-06-08 19:30:00	SPY	ETF	106.58	106.59	106.36	106.38	88355.0
2010-06-08 04:00:00	QQQ	ETF	44.45	44.45	44.45	44.45	300.0
2010-06-08 04:30:00	QQQ	ETF	44.36	44.36	44.36	44.36	100.0
2010-06-08 05:00:00	QQQ	ETF	44.27	44.27	44.15	44.15	20200.0
2010-06-08 05:30:00	QQQ	ETF	44.21	44.26	44.21	44.26	2000.0
2010-06-08 06:00:00	QQQ	ETF	44.27	44.35	44.27	44.34	7600.0
2010-06-08 06:30:00	QQQ	ETF	44.39	44.39	44.27	44.27	11081.0
2010-06-08 07:00:00	QQQ	ETF	44.27	44.4	44.27	44.34	33944.0
2010-06-08 07:30:00	QQQ	ETF	44.34	44.4	44.3	44.32	40612.0
2010-06-08 08:00:00	QQQ	ETF	44.35	44.49	44.32	44.46	281484.0
2010-06-08 08:30:00	QQQ	ETF	44.46	44.5	44.36	44.43	235196.0
2010-06-08 09:00:00	QQQ	ETF	44.44	44.49	44.35	44.37	475182.0
2010-06-08 09:30:00	QQQ	ETF	44.37	44.48	43.93	44.01	10924085.0
2010-06-08 10:00:00	QQQ	ETF	44.01	44.22	43.82	43.98	11231896.0
2010-06-08 10:30:00	QQQ	ETF	43.99	44.05	43.65	43.89	8572617.0
2010-06-08 11:00:00	QQQ	ETF	43.9	44.17	43.63	44.06	13491562.0
2010-06-08 11:30:00	QQQ	ETF	44.05	44.36	44.03	44.23	10720635.0
2010-06-08 12:00:00	QQQ	ETF	44.2201	44.3	44.02	44.05	4960261.0
2010-06-08 12:30:00	QQQ	ETF	44.05	44.14	44.0	44.12	3430476.0

> showing 50 of 8,619 rows — these rows as CSV

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