PREVIEW / etf_30min / 2010-08-31

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-08-31.parquet
  size:    259 KB
  rows:    8,641

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-08-31 04:00:00	SPY	ETF	105.0	105.0	104.62	104.77	800.0
2010-08-31 04:30:00	SPY	ETF	104.82	104.86	104.72	104.72	3900.0
2010-08-31 05:00:00	SPY	ETF	104.67	104.74	104.67	104.74	1100.0
2010-08-31 05:30:00	SPY	ETF	104.78	104.94	104.77	104.94	13250.0
2010-08-31 06:00:00	SPY	ETF	104.86	104.86	104.79	104.82	18100.0
2010-08-31 06:30:00	SPY	ETF	104.82	104.84	104.66	104.7	16400.0
2010-08-31 07:00:00	SPY	ETF	104.68	104.72	104.5	104.52	130940.0
2010-08-31 07:30:00	SPY	ETF	104.52	104.76	104.51	104.74	132850.0
2010-08-31 08:00:00	SPY	ETF	104.76	104.77	104.54	104.63	457452.0
2010-08-31 08:30:00	SPY	ETF	104.63	104.66	104.46	104.63	939900.0
2010-08-31 09:00:00	SPY	ETF	104.67	105.08	104.65	104.92	3233232.0
2010-08-31 09:30:00	SPY	ETF	104.92	105.3	104.49	105.1	39142656.0
2010-08-31 10:00:00	SPY	ETF	105.1	105.85	104.7836	105.68	24506180.0
2010-08-31 10:30:00	SPY	ETF	105.68	105.8	105.2501	105.6775	20670379.0
2010-08-31 11:00:00	SPY	ETF	105.68	105.8	105.34	105.63	14078947.0
2010-08-31 11:30:00	SPY	ETF	105.63	105.98	105.57	105.81	15345681.0
2010-08-31 12:00:00	SPY	ETF	105.81	105.9	105.57	105.62	6181968.0
2010-08-31 12:30:00	SPY	ETF	105.61	105.74	105.4	105.4	6361317.0
2010-08-31 13:00:00	SPY	ETF	105.4	105.72	105.37	105.66	5970047.0
2010-08-31 13:30:00	SPY	ETF	105.67	105.8	105.6	105.64	6079992.0
2010-08-31 14:00:00	SPY	ETF	105.63	105.86	105.21	105.35	18554442.0
2010-08-31 14:30:00	SPY	ETF	105.34	105.36	104.83	104.98	22084578.0
2010-08-31 15:00:00	SPY	ETF	104.97	105.19	104.86	105.06	19887864.0
2010-08-31 15:30:00	SPY	ETF	105.07	105.61	104.9	105.4	45889682.0
2010-08-31 16:00:00	SPY	ETF	105.4	105.915	104.595	105.74	18112153.0
2010-08-31 16:30:00	SPY	ETF	105.73	105.87	105.26	105.85	2969738.0
2010-08-31 17:00:00	SPY	ETF	105.85	105.88	105.78	105.79	1383690.0
2010-08-31 17:30:00	SPY	ETF	105.77	105.8	105.72	105.72	79699.0
2010-08-31 18:00:00	SPY	ETF	105.76	105.82	105.75	105.78	70953.0
2010-08-31 18:30:00	SPY	ETF	105.8	105.88	105.8	105.83	127527.0
2010-08-31 19:00:00	SPY	ETF	105.86	105.86	105.75	105.75	22478.0
2010-08-31 19:30:00	SPY	ETF	105.76	105.8	105.71	105.78	107499.0
2010-08-31 04:00:00	QQQ	ETF	43.27	43.33	43.27	43.33	7608.0
2010-08-31 04:30:00	QQQ	ETF	43.37	43.37	43.33	43.33	450.0
2010-08-31 05:00:00	QQQ	ETF	43.36	43.36	43.36	43.36	100.0
2010-08-31 05:30:00	QQQ	ETF	43.36	43.36	43.35	43.35	200.0
2010-08-31 06:30:00	QQQ	ETF	43.36	43.36	43.3	43.3	2000.0
2010-08-31 07:00:00	QQQ	ETF	43.31	43.33	43.23	43.24	59500.0
2010-08-31 07:30:00	QQQ	ETF	43.26	43.34	43.26	43.34	4478.0
2010-08-31 08:00:00	QQQ	ETF	43.35	43.36	43.27	43.3	89613.0
2010-08-31 08:30:00	QQQ	ETF	43.29	43.31	43.24	43.29	80648.0
2010-08-31 09:00:00	QQQ	ETF	43.31	43.46	43.27	43.39	798009.0
2010-08-31 09:30:00	QQQ	ETF	43.39	43.6	43.18	43.52	12232100.0
2010-08-31 10:00:00	QQQ	ETF	43.53	43.85	43.47	43.7	8689684.0
2010-08-31 10:30:00	QQQ	ETF	43.71	43.76	43.49	43.63	4525878.0
2010-08-31 11:00:00	QQQ	ETF	43.62	43.66	43.45	43.58	3000927.0
2010-08-31 11:30:00	QQQ	ETF	43.57	43.73	43.56	43.67	3260610.0
2010-08-31 12:00:00	QQQ	ETF	43.67	43.72	43.6	43.64	1183448.0
2010-08-31 12:30:00	QQQ	ETF	43.64	43.71	43.5	43.5	2683024.0
2010-08-31 13:00:00	QQQ	ETF	43.5	43.68	43.48	43.65	2715833.0

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

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