PREVIEW / etf_30min / 2007-05-11

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-05-11.parquet
  size:    107 KB
  rows:    3,935

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-05-11 04:30:00	SPY	ETF	149.42	149.42	149.42	149.42	500.0
2007-05-11 06:30:00	SPY	ETF	149.81	149.81	149.7	149.7	16100.0
2007-05-11 07:00:00	SPY	ETF	149.61	149.76	149.61	149.74	58100.0
2007-05-11 07:30:00	SPY	ETF	149.77	149.77	149.68	149.7	64800.0
2007-05-11 08:00:00	SPY	ETF	149.68	149.79	149.64	149.65	695900.0
2007-05-11 08:30:00	SPY	ETF	149.66	150.03	149.66	149.85	6423700.0
2007-05-11 09:00:00	SPY	ETF	149.85	149.87	149.72	149.75	721600.0
2007-05-11 09:30:00	SPY	ETF	149.75	150.06	149.74	149.83	11713409.0
2007-05-11 10:00:00	SPY	ETF	149.85	150.14	149.72	150.04	13146000.0
2007-05-11 10:30:00	SPY	ETF	150.04	150.55	150.04	150.46	14323432.0
2007-05-11 11:00:00	SPY	ETF	150.46	150.61	150.12	150.47	9950250.0
2007-05-11 11:30:00	SPY	ETF	150.47	150.5	150.25	150.4	5556450.0
2007-05-11 12:00:00	SPY	ETF	150.4	150.43	150.21	150.33	6257650.0
2007-05-11 12:30:00	SPY	ETF	150.33	150.44	150.15	150.38	7029400.0
2007-05-11 13:00:00	SPY	ETF	150.38	150.53	150.29	150.48	4291483.0
2007-05-11 13:30:00	SPY	ETF	150.47	150.5	150.25	150.31	3407945.0
2007-05-11 14:00:00	SPY	ETF	150.31	150.38	150.22	150.26	4082708.0
2007-05-11 14:30:00	SPY	ETF	150.27	150.43	150.19	150.33	4050645.0
2007-05-11 15:00:00	SPY	ETF	150.32	150.65	150.25	150.49	5458444.0
2007-05-11 15:30:00	SPY	ETF	150.49	150.82	150.49	150.81	11046725.0
2007-05-11 16:00:00	SPY	ETF	150.82	150.93	150.74	150.9	2943300.0
2007-05-11 16:30:00	SPY	ETF	150.83	150.98	150.83	150.9	80100.0
2007-05-11 17:00:00	SPY	ETF	150.9	150.9	150.85	150.85	874900.0
2007-05-11 17:30:00	SPY	ETF	150.85	150.9	150.84	150.9	5500.0
2007-05-11 18:00:00	SPY	ETF	150.9	150.9	150.86	150.86	500.0
2007-05-11 18:30:00	SPY	ETF	150.85	150.85	150.85	150.85	1300.0
2007-05-11 19:00:00	SPY	ETF	150.93	150.93	150.93	150.93	500.0
2007-05-11 19:30:00	SPY	ETF	150.91	150.94	150.91	150.94	2100.0
2007-05-11 06:00:00	QQQ	ETF	46.15	46.21	46.15	46.21	800.0
2007-05-11 06:30:00	QQQ	ETF	46.22	46.22	46.22	46.22	300.0
2007-05-11 07:00:00	QQQ	ETF	46.24	46.25	46.22	46.22	85700.0
2007-05-11 07:30:00	QQQ	ETF	46.22	46.22	46.19	46.2	107495.0
2007-05-11 08:00:00	QQQ	ETF	46.2	46.25	46.18	46.22	984430.0
2007-05-11 08:30:00	QQQ	ETF	46.25	46.46	46.09	46.2	2846045.0
2007-05-11 09:00:00	QQQ	ETF	46.21	46.22	46.15	46.19	327211.0
2007-05-11 09:30:00	QQQ	ETF	46.24	46.36	46.22	46.22	6025156.0
2007-05-11 10:00:00	QQQ	ETF	46.22	46.34	46.18	46.27	11494444.0
2007-05-11 10:30:00	QQQ	ETF	46.27	46.49	46.27	46.47	11157121.0
2007-05-11 11:00:00	QQQ	ETF	46.47	46.64	46.46	46.57	11957715.0
2007-05-11 11:30:00	QQQ	ETF	46.56	46.58	46.48	46.56	4922381.0
2007-05-11 12:00:00	QQQ	ETF	46.56	46.58	46.46	46.55	4060715.0
2007-05-11 12:30:00	QQQ	ETF	46.54	46.6	46.51	46.56	3737518.0
2007-05-11 13:00:00	QQQ	ETF	46.55	46.63	46.5	46.6	6120447.0
2007-05-11 13:30:00	QQQ	ETF	46.6	46.61	46.52	46.56	3292946.0
2007-05-11 14:00:00	QQQ	ETF	46.55	46.59	46.52	46.53	3229325.0
2007-05-11 14:30:00	QQQ	ETF	46.53	46.58	46.5	46.57	3577930.0
2007-05-11 15:00:00	QQQ	ETF	46.56	46.64	46.54	46.62	4517950.0
2007-05-11 15:30:00	QQQ	ETF	46.63	46.74	46.62	46.73	12732937.0
2007-05-11 16:00:00	QQQ	ETF	46.73	46.8	46.54	46.8	1416697.0
2007-05-11 16:30:00	QQQ	ETF	46.79	46.8	46.76	46.76	30094.0

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

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