PREVIEW / etf_30min / 2007-04-13

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-04-13.parquet
  size:    105 KB
  rows:    3,692

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-04-13 06:00:00	SPY	ETF	144.66	144.66	144.62	144.62	10500.0
2007-04-13 07:00:00	SPY	ETF	144.59	144.6	144.52	144.56	28900.0
2007-04-13 07:30:00	SPY	ETF	144.59	144.6	144.53	144.6	112900.0
2007-04-13 08:00:00	SPY	ETF	144.6	144.67	144.54	144.58	500000.0
2007-04-13 08:30:00	SPY	ETF	144.7	145.08	144.7	144.81	3290200.0
2007-04-13 09:00:00	SPY	ETF	144.85	144.96	144.85	144.89	379300.0
2007-04-13 09:30:00	SPY	ETF	144.9	145.0	144.67	144.88	7759210.0
2007-04-13 10:00:00	SPY	ETF	144.88	144.88	144.36	144.49	17815749.0
2007-04-13 10:30:00	SPY	ETF	144.5	144.92	144.47	144.78	8292168.0
2007-04-13 11:00:00	SPY	ETF	144.77	144.94	144.74	144.83	4432047.0
2007-04-13 11:30:00	SPY	ETF	144.83	145.0	144.76	144.91	3906935.0
2007-04-13 12:00:00	SPY	ETF	144.91	144.96	144.76	144.87	2805763.0
2007-04-13 12:30:00	SPY	ETF	144.8726	145.02	144.79	144.94	2984654.0
2007-04-13 13:00:00	SPY	ETF	144.94	145.04	144.79	144.921	3140750.0
2007-04-13 13:30:00	SPY	ETF	144.93	145.12	144.88	145.1	4894307.0
2007-04-13 14:00:00	SPY	ETF	145.09	145.13	144.94	145.04	2562133.0
2007-04-13 14:30:00	SPY	ETF	145.05	145.28	145.0	145.19	6668799.0
2007-04-13 15:00:00	SPY	ETF	145.19	145.29	145.12	145.21	4017164.0
2007-04-13 15:30:00	SPY	ETF	145.2	145.29	145.19	145.25	4410361.0
2007-04-13 16:00:00	SPY	ETF	145.26	145.3	145.21	145.26	2506600.0
2007-04-13 16:30:00	SPY	ETF	145.25	145.3	145.25	145.3	2097400.0
2007-04-13 17:00:00	SPY	ETF	145.3	145.32	145.26	145.26	24100.0
2007-04-13 17:30:00	SPY	ETF	145.26	145.26	145.25	145.26	863200.0
2007-04-13 18:00:00	SPY	ETF	145.25	145.27	145.2	145.27	8000.0
2007-04-13 19:30:00	SPY	ETF	145.24	145.24	145.24	145.24	100.0
2007-04-13 05:30:00	QQQ	ETF	44.5	44.5	44.5	44.5	100.0
2007-04-13 07:00:00	QQQ	ETF	44.47	44.5	44.46	44.48	29100.0
2007-04-13 07:30:00	QQQ	ETF	44.48	44.49	44.46	44.48	47738.0
2007-04-13 08:00:00	QQQ	ETF	44.49	44.5	44.45	44.5	218089.0
2007-04-13 08:30:00	QQQ	ETF	44.53	44.7	44.5	44.58	2589515.0
2007-04-13 09:00:00	QQQ	ETF	44.59	44.62	44.57	44.58	515943.0
2007-04-13 09:30:00	QQQ	ETF	44.57	44.6	44.44	44.47	9870100.0
2007-04-13 10:00:00	QQQ	ETF	44.48	44.48	44.29	44.36	11370800.0
2007-04-13 10:30:00	QQQ	ETF	44.36	44.52	44.35	44.43	8550800.0
2007-04-13 11:00:00	QQQ	ETF	44.44	44.49	44.42	44.44	3149300.0
2007-04-13 11:30:00	QQQ	ETF	44.43	44.51	44.41	44.49	4261600.0
2007-04-13 12:00:00	QQQ	ETF	44.49	44.5	44.38	44.42	3486600.0
2007-04-13 12:30:00	QQQ	ETF	44.41	44.49	44.39	44.43	2746200.0
2007-04-13 13:00:00	QQQ	ETF	44.43	44.46	44.38	44.42	1726100.0
2007-04-13 13:30:00	QQQ	ETF	44.42	44.51	44.42	44.5	1936100.0
2007-04-13 14:00:00	QQQ	ETF	44.49	44.5	44.42	44.48	2078100.0
2007-04-13 14:30:00	QQQ	ETF	44.48	44.7	44.48	44.63	18074200.0
2007-04-13 15:00:00	QQQ	ETF	44.64	44.72	44.61	44.69	10759200.0
2007-04-13 15:30:00	QQQ	ETF	44.69	44.7	44.63	44.67	9009300.0
2007-04-13 16:00:00	QQQ	ETF	44.67	44.76	44.63	44.73	2772330.0
2007-04-13 16:30:00	QQQ	ETF	44.75	44.76	44.45	44.69	347700.0
2007-04-13 17:00:00	QQQ	ETF	44.69	44.72	44.68	44.7	22685.0
2007-04-13 17:30:00	QQQ	ETF	44.72	44.72	44.69	44.69	249905.0
2007-04-13 18:00:00	QQQ	ETF	44.7	44.7	44.65	44.66	32425.0
2007-04-13 18:30:00	QQQ	ETF	44.66	44.68	44.66	44.68	6100.0

> showing 50 of 3,692 rows — these rows as CSV

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