PREVIEW / etf_30min / 2006-05-23

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-05-23.parquet
  size:    71 KB
  rows:    2,478

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
2006-05-23 04:00:00	SPY	ETF	126.81	126.81	126.81	126.81	100.0
2006-05-23 05:30:00	SPY	ETF	126.77	126.8	126.77	126.8	2300.0
2006-05-23 06:30:00	SPY	ETF	126.6	126.7	126.6	126.67	25500.0
2006-05-23 07:00:00	SPY	ETF	126.65	126.79	126.61	126.74	142500.0
2006-05-23 07:30:00	SPY	ETF	126.84	126.89	126.81	126.81	246800.0
2006-05-23 08:00:00	SPY	ETF	126.81	127.06	126.6	126.91	1966900.0
2006-05-23 08:30:00	SPY	ETF	126.93	127.02	126.69	127.0	712100.0
2006-05-23 09:00:00	SPY	ETF	126.99	127.24	126.97	127.2	1576300.0
2006-05-23 09:30:00	SPY	ETF	127.18	127.45	127.11	127.23	10757900.0
2006-05-23 10:00:00	SPY	ETF	127.23	127.53	126.93	127.45	6287300.0
2006-05-23 10:30:00	SPY	ETF	127.46	127.63	127.32	127.3876	5801400.0
2006-05-23 11:00:00	SPY	ETF	127.39	127.51	127.1	127.24	5447100.0
2006-05-23 11:30:00	SPY	ETF	127.24	127.45	127.16	127.16	2785700.0
2006-05-23 12:00:00	SPY	ETF	127.16	127.25	126.99	127.07	3208900.0
2006-05-23 12:30:00	SPY	ETF	127.08	127.18	126.97	127.05	3358000.0
2006-05-23 13:00:00	SPY	ETF	127.06	127.29	127.04	127.28	3058900.0
2006-05-23 13:30:00	SPY	ETF	127.28	127.46	127.17	127.21	2732100.0
2006-05-23 14:00:00	SPY	ETF	127.21	127.29	127.01	127.11	2243700.0
2006-05-23 14:30:00	SPY	ETF	127.11	127.27	126.72	126.82	8169500.0
2006-05-23 15:00:00	SPY	ETF	126.82	127.06	126.64	126.77	5093400.0
2006-05-23 15:30:00	SPY	ETF	126.79	126.81	125.81	125.86	13733300.0
2006-05-23 16:00:00	SPY	ETF	125.85	125.88	125.12	125.18	4345500.0
2006-05-23 16:30:00	SPY	ETF	125.19	125.31	124.69	124.8	2005000.0
2006-05-23 17:00:00	SPY	ETF	124.79	124.9	124.7	124.77	877200.0
2006-05-23 17:30:00	SPY	ETF	124.69	125.2	124.67	124.69	762600.0
2006-05-23 18:00:00	SPY	ETF	124.7	125.0	124.68	124.9	43000.0
2006-05-23 18:30:00	SPY	ETF	124.9	124.91	124.8	124.8	4100.0
2006-05-23 19:00:00	SPY	ETF	124.78	124.8	124.75	124.75	11400.0
2006-05-23 19:30:00	SPY	ETF	124.74	124.79	124.74	124.79	2300.0
2006-05-23 09:30:00	QQQ	ETF	39.27	39.36	39.2	39.25	15300900.0
2006-05-23 10:00:00	QQQ	ETF	39.26	39.38	39.18	39.31	8305400.0
2006-05-23 10:30:00	QQQ	ETF	39.32	39.38	39.32	39.35	6895600.0
2006-05-23 11:00:00	QQQ	ETF	39.35	39.37	39.17	39.26	9073400.0
2006-05-23 11:30:00	QQQ	ETF	39.27	39.37	39.25	39.27	4107400.0
2006-05-23 12:00:00	QQQ	ETF	39.26	39.32	39.22	39.27	4282500.0
2006-05-23 12:30:00	QQQ	ETF	39.28	39.28	39.2	39.2	3127000.0
2006-05-23 13:00:00	QQQ	ETF	39.21	39.3	39.2	39.29	3985300.0
2006-05-23 13:30:00	QQQ	ETF	39.28	39.35	39.21	39.23	5069800.0
2006-05-23 14:00:00	QQQ	ETF	39.23	39.27	39.15	39.18	7841800.0
2006-05-23 14:30:00	QQQ	ETF	39.18	39.22	38.98	39.01	13600300.0
2006-05-23 15:00:00	QQQ	ETF	39.01	39.2	38.91	38.94	13020700.0
2006-05-23 15:30:00	QQQ	ETF	38.94	38.96	38.57	38.57	23970000.0
2006-05-23 08:00:00	IWM	ETF	71.61	71.76	71.59	71.63	199200.0
2006-05-23 08:30:00	IWM	ETF	71.62	71.78	71.61	71.78	93300.0
2006-05-23 09:00:00	IWM	ETF	71.77	72.01	71.77	71.89	1129900.0
2006-05-23 09:30:00	IWM	ETF	71.88	72.29	71.77	72.0	17602300.0
2006-05-23 10:00:00	IWM	ETF	72.0	72.24	71.92	72.18	6860200.0
2006-05-23 10:30:00	IWM	ETF	72.17	72.39	71.98	72.09	5519200.0
2006-05-23 11:00:00	IWM	ETF	72.09	72.14	71.84	71.88	2040900.0
2006-05-23 11:30:00	IWM	ETF	71.88	72.09	71.79	71.8	1528800.0

> showing 50 of 2,478 rows — these rows as CSV

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