PREVIEW / etf_30min / 2007-06-13

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-06-13.parquet
  size:    119 KB
  rows:    4,461

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
2007-06-13 04:30:00	SPY	ETF	149.76	149.76	149.76	149.76	6100.0
2007-06-13 05:00:00	SPY	ETF	149.59	149.59	149.59	149.59	19900.0
2007-06-13 05:30:00	SPY	ETF	149.5	149.5	149.36	149.48	9400.0
2007-06-13 06:00:00	SPY	ETF	149.56	149.84	149.56	149.84	23000.0
2007-06-13 06:30:00	SPY	ETF	149.76	149.81	149.71	149.8	17000.0
2007-06-13 07:00:00	SPY	ETF	149.81	150.06	149.78	149.91	427400.0
2007-06-13 07:30:00	SPY	ETF	149.94	150.09	149.89	150.07	210200.0
2007-06-13 08:00:00	SPY	ETF	150.04	150.11	149.93	150.08	796400.0
2007-06-13 08:30:00	SPY	ETF	150.09	150.52	149.54	150.42	8591700.0
2007-06-13 09:00:00	SPY	ETF	150.4	150.71	149.25	150.42	2471900.0
2007-06-13 09:30:00	SPY	ETF	150.44	150.62	150.25	150.41	11274500.0
2007-06-13 10:00:00	SPY	ETF	150.41	151.02	150.21	150.86	17540400.0
2007-06-13 10:30:00	SPY	ETF	150.86	151.01	150.69	150.79	8136100.0
2007-06-13 11:00:00	SPY	ETF	150.79	150.87	150.4	150.48	8357600.0
2007-06-13 11:30:00	SPY	ETF	150.48	150.72	150.47	150.62	5079000.0
2007-06-13 12:00:00	SPY	ETF	150.63	150.69	150.44	150.5	4698900.0
2007-06-13 12:30:00	SPY	ETF	150.5	150.85	150.41	150.45	8007300.0
2007-06-13 13:00:00	SPY	ETF	150.46	150.57	150.19	150.33	8467126.0
2007-06-13 13:30:00	SPY	ETF	150.34	150.63	150.26	150.6	4774400.0
2007-06-13 14:00:00	SPY	ETF	150.6	151.32	150.58	151.1	27167110.0
2007-06-13 14:30:00	SPY	ETF	151.1	151.67	151.05	151.6225	34573700.0
2007-06-13 15:00:00	SPY	ETF	151.61	151.67	150.51	151.38	11911500.0
2007-06-13 15:30:00	SPY	ETF	151.38	151.98	151.36	151.95	20397700.0
2007-06-13 16:00:00	SPY	ETF	151.97	152.06	151.86	151.9	2945600.0
2007-06-13 16:30:00	SPY	ETF	151.9	151.9	151.8	151.86	2368100.0
2007-06-13 17:00:00	SPY	ETF	151.87	151.995	151.82	151.82	2169400.0
2007-06-13 17:30:00	SPY	ETF	151.86	151.86	151.8	151.8	7000.0
2007-06-13 18:00:00	SPY	ETF	151.85	151.85	151.75	151.83	19200.0
2007-06-13 18:30:00	SPY	ETF	151.82	151.85	151.81	151.85	13400.0
2007-06-13 19:00:00	SPY	ETF	151.85	151.85	151.85	151.85	1000.0
2007-06-13 19:30:00	SPY	ETF	151.85	151.93	151.83	151.93	4000.0
2007-06-13 06:00:00	QQQ	ETF	46.57	46.58	46.57	46.58	15000.0
2007-06-13 07:00:00	QQQ	ETF	46.56	46.68	46.56	46.66	81900.0
2007-06-13 07:30:00	QQQ	ETF	46.62	46.7	46.6	46.7	184481.0
2007-06-13 08:00:00	QQQ	ETF	46.67	46.68	46.63	46.67	675337.0
2007-06-13 08:30:00	QQQ	ETF	46.67	46.82	46.48	46.75	5759469.0
2007-06-13 09:00:00	QQQ	ETF	46.76	46.85	46.73	46.74	1609441.0
2007-06-13 09:30:00	QQQ	ETF	46.74	46.76	46.54	46.72	13065697.0
2007-06-13 10:00:00	QQQ	ETF	46.72	46.88	46.66	46.8	13758360.0
2007-06-13 10:30:00	QQQ	ETF	46.8	46.85	46.691	46.79	4863732.0
2007-06-13 11:00:00	QQQ	ETF	46.7815	46.8	46.67	46.69	6319816.0
2007-06-13 11:30:00	QQQ	ETF	46.69	46.74	46.65	46.7	5577819.0
2007-06-13 12:00:00	QQQ	ETF	46.7	46.73	46.58	46.62	6672771.0
2007-06-13 12:30:00	QQQ	ETF	46.62	46.74	46.59	46.64	9381358.0
2007-06-13 13:00:00	QQQ	ETF	46.6515	46.66	46.56	46.61	9044671.0
2007-06-13 13:30:00	QQQ	ETF	46.62	46.68	46.58	46.67	5325316.0
2007-06-13 14:00:00	QQQ	ETF	46.67	46.9	46.65	46.84	10187403.0
2007-06-13 14:30:00	QQQ	ETF	46.84	46.94	46.82	46.92	6430842.0
2007-06-13 15:00:00	QQQ	ETF	46.92	46.97	46.83	46.85	15980839.0
2007-06-13 15:30:00	QQQ	ETF	46.86	47.09	46.86	47.06	21459819.0

> showing 50 of 4,461 rows — these rows as CSV

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