PREVIEW / etf_30min / 2008-01-25

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-01-25.parquet
  size:    161 KB
  rows:    5,744

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
2008-01-25 04:00:00	SPY	ETF	136.15	136.15	135.87	135.87	3100.0
2008-01-25 04:30:00	SPY	ETF	135.72	135.75	135.55	135.75	30200.0
2008-01-25 05:00:00	SPY	ETF	135.77	135.93	135.72	135.93	2200.0
2008-01-25 05:30:00	SPY	ETF	135.73	135.75	135.72	135.75	12000.0
2008-01-25 06:00:00	SPY	ETF	135.81	135.93	135.81	135.93	31500.0
2008-01-25 06:30:00	SPY	ETF	136.01	136.1	135.97	135.98	14200.0
2008-01-25 07:00:00	SPY	ETF	135.88	135.95	135.7	135.77	308600.0
2008-01-25 07:30:00	SPY	ETF	135.77	136.07	135.67	136.03	286800.0
2008-01-25 08:00:00	SPY	ETF	135.99	136.2	135.84	135.85	1101200.0
2008-01-25 08:30:00	SPY	ETF	135.86	136.25	135.86	136.2	2511500.0
2008-01-25 09:00:00	SPY	ETF	136.2	136.54	136.03	136.5	3375372.0
2008-01-25 09:30:00	SPY	ETF	136.49	136.76	135.91	136.08	26609015.0
2008-01-25 10:00:00	SPY	ETF	136.08	136.22	135.5	135.67	20005769.0
2008-01-25 10:30:00	SPY	ETF	135.66	136.57	134.75	134.84	28040701.0
2008-01-25 11:00:00	SPY	ETF	134.85	136.51	134.4	134.59	17697856.0
2008-01-25 11:30:00	SPY	ETF	134.59	135.4	134.5	135.24	22763277.0
2008-01-25 12:00:00	SPY	ETF	135.25	135.35	134.85	134.89	10365897.0
2008-01-25 12:30:00	SPY	ETF	134.8985	134.91	133.77	133.98	14945908.0
2008-01-25 13:00:00	SPY	ETF	133.98	134.31	133.58	133.67	13017330.0
2008-01-25 13:30:00	SPY	ETF	133.67	135.3001	132.6	133.03	27424124.0
2008-01-25 14:00:00	SPY	ETF	133.01	133.55	132.85	133.17	16757182.0
2008-01-25 14:30:00	SPY	ETF	133.17	135.1218	132.67	133.09	17944279.0
2008-01-25 15:00:00	SPY	ETF	133.09	134.035	132.91	133.69	15865860.0
2008-01-25 15:30:00	SPY	ETF	133.69	134.05	132.63	132.98	20791034.0
2008-01-25 16:00:00	SPY	ETF	132.98	135.83	132.82	133.0	6051000.0
2008-01-25 16:30:00	SPY	ETF	133.16	133.27	133.0	133.21	1815073.0
2008-01-25 17:00:00	SPY	ETF	133.21	135.29	133.08	133.19	962500.0
2008-01-25 17:30:00	SPY	ETF	133.14	133.35	133.14	133.22	52500.0
2008-01-25 18:00:00	SPY	ETF	133.23	133.33	133.2	133.3	29100.0
2008-01-25 18:30:00	SPY	ETF	133.3	133.32	133.3	133.3	7500.0
2008-01-25 19:00:00	SPY	ETF	133.3	133.34	133.2	133.2	1800.0
2008-01-25 19:30:00	SPY	ETF	133.02	133.15	133.02	133.1	1200.0
2008-01-25 04:30:00	QQQ	ETF	45.44	45.44	45.44	45.44	400.0
2008-01-25 05:00:00	QQQ	ETF	45.47	45.53	45.47	45.53	2000.0
2008-01-25 06:30:00	QQQ	ETF	45.56	45.56	45.55	45.55	50500.0
2008-01-25 07:00:00	QQQ	ETF	45.51	45.54	45.42	45.49	401916.0
2008-01-25 07:30:00	QQQ	ETF	45.48	45.56	45.45	45.54	139660.0
2008-01-25 08:00:00	QQQ	ETF	45.55	45.63	45.49	45.56	737110.0
2008-01-25 08:30:00	QQQ	ETF	45.56	45.77	45.56	45.76	1106161.0
2008-01-25 09:00:00	QQQ	ETF	45.76	45.88	45.62	45.85	3522541.0
2008-01-25 09:30:00	QQQ	ETF	45.85	45.87	45.3	45.35	27478042.0
2008-01-25 10:00:00	QQQ	ETF	45.35	45.36	45.02	45.1	17274402.0
2008-01-25 10:30:00	QQQ	ETF	45.1	45.13	44.71	44.78	20673011.0
2008-01-25 11:00:00	QQQ	ETF	44.79	44.9	44.59	44.64	17451898.0
2008-01-25 11:30:00	QQQ	ETF	44.64	44.95	44.64	44.9	10286190.0
2008-01-25 12:00:00	QQQ	ETF	44.9	44.96	44.8	44.86	4813920.0
2008-01-25 12:30:00	QQQ	ETF	44.86	44.86	44.42	44.48	10957956.0
2008-01-25 13:00:00	QQQ	ETF	44.48	44.58	44.37	44.41	10350165.0
2008-01-25 13:30:00	QQQ	ETF	44.4	44.45	44.11	44.17	15693606.0
2008-01-25 14:00:00	QQQ	ETF	44.17	44.4	44.07	44.25	10426222.0

> showing 50 of 5,744 rows — these rows as CSV

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