PREVIEW / etf_30min / 2010-11-08

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-11-08.parquet
  size:    266 KB
  rows:    9,041

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-11-08 04:00:00	SPY	ETF	122.48	122.51	122.22	122.22	2650.0
2010-11-08 04:30:00	SPY	ETF	122.27	122.3	122.27	122.27	500.0
2010-11-08 05:00:00	SPY	ETF	122.37	122.42	122.37	122.42	600.0
2010-11-08 05:30:00	SPY	ETF	122.42	122.42	122.15	122.25	15288.0
2010-11-08 06:00:00	SPY	ETF	122.21	122.21	122.21	122.21	600.0
2010-11-08 06:30:00	SPY	ETF	122.29	122.32	122.21	122.3	5588.0
2010-11-08 07:00:00	SPY	ETF	122.3	122.45	122.28	122.35	137187.0
2010-11-08 07:30:00	SPY	ETF	122.37	122.39	122.29	122.31	190556.0
2010-11-08 08:00:00	SPY	ETF	122.31	122.38	122.27	122.3	1618812.0
2010-11-08 08:30:00	SPY	ETF	122.3	122.43	122.29	122.32	690707.0
2010-11-08 09:00:00	SPY	ETF	122.31	122.34	122.22	122.34	686856.0
2010-11-08 09:30:00	SPY	ETF	122.34	122.48	122.05	122.11	19135600.0
2010-11-08 10:00:00	SPY	ETF	122.11	122.37	122.0	122.32	12679699.0
2010-11-08 10:30:00	SPY	ETF	122.3189	122.38	122.06	122.08	11667255.0
2010-11-08 11:00:00	SPY	ETF	122.07	122.24	121.94	122.19	10907676.0
2010-11-08 11:30:00	SPY	ETF	122.19	122.43	122.18	122.37	6954817.0
2010-11-08 12:00:00	SPY	ETF	122.37	122.55	122.2901	122.48	6205437.0
2010-11-08 12:30:00	SPY	ETF	122.48	122.5	122.36	122.39	4208600.0
2010-11-08 13:00:00	SPY	ETF	122.4	122.58	122.3801	122.485	7638912.0
2010-11-08 13:30:00	SPY	ETF	122.49	122.51	122.3	122.41	8125941.0
2010-11-08 14:00:00	SPY	ETF	122.41	122.62	122.4	122.52	5639290.0
2010-11-08 14:30:00	SPY	ETF	122.515	122.52	122.35	122.37	7819620.0
2010-11-08 15:00:00	SPY	ETF	122.37	122.58	122.31	122.55	7522885.0
2010-11-08 15:30:00	SPY	ETF	122.55	122.69	122.34	122.54	20707084.0
2010-11-08 16:00:00	SPY	ETF	122.53	122.7833	122.135	122.44	13417900.0
2010-11-08 16:30:00	SPY	ETF	122.43	122.44	122.33	122.33	2163264.0
2010-11-08 17:00:00	SPY	ETF	122.33	122.33	122.24	122.3	2069472.0
2010-11-08 17:30:00	SPY	ETF	122.33	122.34	122.29	122.3	40280.0
2010-11-08 18:00:00	SPY	ETF	122.3	122.54	122.23	122.31	112217.0
2010-11-08 18:30:00	SPY	ETF	122.32	122.33	122.13	122.18	122715.0
2010-11-08 19:00:00	SPY	ETF	122.18	122.18	122.02	122.04	76761.0
2010-11-08 19:30:00	SPY	ETF	122.05	122.11	122.03	122.05	41133.0
2010-11-08 04:00:00	QQQ	ETF	53.63	53.63	53.63	53.63	100.0
2010-11-08 04:30:00	QQQ	ETF	53.61	53.61	53.61	53.61	200.0
2010-11-08 05:30:00	QQQ	ETF	53.52	53.54	53.52	53.54	4500.0
2010-11-08 06:30:00	QQQ	ETF	53.55	53.55	53.5	53.5	10000.0
2010-11-08 07:00:00	QQQ	ETF	53.59	53.63	53.55	53.58	15600.0
2010-11-08 07:30:00	QQQ	ETF	53.58	53.6	53.55	53.56	19400.0
2010-11-08 08:00:00	QQQ	ETF	53.56	53.58	53.56	53.56	42065.0
2010-11-08 08:30:00	QQQ	ETF	53.56	53.61	53.56	53.58	159177.0
2010-11-08 09:00:00	QQQ	ETF	53.57	53.59	53.54	53.58	396945.0
2010-11-08 09:30:00	QQQ	ETF	53.57	53.67	53.4499	53.52	6614265.0
2010-11-08 10:00:00	QQQ	ETF	53.52	53.79	53.4601	53.7399	4616579.0
2010-11-08 10:30:00	QQQ	ETF	53.73	53.79	53.68	53.68	2696446.0
2010-11-08 11:00:00	QQQ	ETF	53.68	53.73	53.62	53.7	3476982.0
2010-11-08 11:30:00	QQQ	ETF	53.71	53.78	53.71	53.7501	1928114.0
2010-11-08 12:00:00	QQQ	ETF	53.76	53.83	53.7248	53.78	1636103.0
2010-11-08 12:30:00	QQQ	ETF	53.78	53.79	53.75	53.77	888203.0
2010-11-08 13:00:00	QQQ	ETF	53.765	53.82	53.74	53.7573	1198388.0
2010-11-08 13:30:00	QQQ	ETF	53.76	53.77	53.68	53.72	1231632.0

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

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