PREVIEW / etf_30min / 2008-10-06

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-10-06.parquet
  size:    194 KB
  rows:    6,896

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-10-06 04:00:00	SPY	ETF	107.72	107.75	107.5	107.67	1300.0
2008-10-06 04:30:00	SPY	ETF	107.57	107.57	107.31	107.31	3100.0
2008-10-06 05:00:00	SPY	ETF	107.49	107.53	107.35	107.41	9600.0
2008-10-06 05:30:00	SPY	ETF	107.31	107.31	106.86	107.05	12800.0
2008-10-06 06:00:00	SPY	ETF	107.05	107.7	106.96	107.5	75683.0
2008-10-06 06:30:00	SPY	ETF	107.58	108.28	107.56	107.66	201717.0
2008-10-06 07:00:00	SPY	ETF	107.75	107.88	107.34	107.67	880470.0
2008-10-06 07:30:00	SPY	ETF	107.68	108.09	107.24	107.78	1446394.0
2008-10-06 08:00:00	SPY	ETF	107.78	109.62	107.08	107.79	4865051.0
2008-10-06 08:30:00	SPY	ETF	107.79	108.05	107.5	107.69	2457309.0
2008-10-06 09:00:00	SPY	ETF	107.7	108.45	107.05	107.11	4301380.0
2008-10-06 09:30:00	SPY	ETF	107.15	107.62	105.77	106.15	51159436.0
2008-10-06 10:00:00	SPY	ETF	106.15	107.05	104.53	104.76	44945507.0
2008-10-06 10:30:00	SPY	ETF	104.75	105.0	102.53	104.34	54042264.0
2008-10-06 11:00:00	SPY	ETF	104.35	105.62	104.11	105.05	47042855.0
2008-10-06 11:30:00	SPY	ETF	105.04	105.1	103.94	104.31	30030697.0
2008-10-06 12:00:00	SPY	ETF	104.31	104.79	103.87	104.09	17016253.0
2008-10-06 12:30:00	SPY	ETF	104.09	104.25	103.16	103.3596	18657747.0
2008-10-06 13:00:00	SPY	ETF	103.35	107.22	102.96	103.79	26037416.0
2008-10-06 13:30:00	SPY	ETF	103.79	104.0	102.62	103.29	22328964.0
2008-10-06 14:00:00	SPY	ETF	103.29	104.2398	101.27	101.6	39912138.0
2008-10-06 14:30:00	SPY	ETF	101.59	102.3	100.64	101.93	51133479.0
2008-10-06 15:00:00	SPY	ETF	101.94	105.5	101.31	104.7601	81270404.0
2008-10-06 15:30:00	SPY	ETF	104.86	106.44	103.61	106.27	74123799.0
2008-10-06 16:00:00	SPY	ETF	106.25	109.8553	103.5149	104.79	16756844.0
2008-10-06 16:30:00	SPY	ETF	104.8	105.63	104.44	104.58	13427341.0
2008-10-06 17:00:00	SPY	ETF	104.58	109.86	104.48	104.81	2321584.0
2008-10-06 17:30:00	SPY	ETF	104.8	104.95	104.67	104.9	239700.0
2008-10-06 18:00:00	SPY	ETF	104.85	104.85	104.42	104.5	209905.0
2008-10-06 18:30:00	SPY	ETF	104.5	104.85	104.5	104.81	73525.0
2008-10-06 19:00:00	SPY	ETF	104.83	104.95	104.81	104.88	44110.0
2008-10-06 19:30:00	SPY	ETF	104.84	104.9	104.46	104.6	64195.0
2008-10-06 04:00:00	QQQ	ETF	35.28	35.31	35.2	35.2	5200.0
2008-10-06 04:30:00	QQQ	ETF	35.39	35.39	35.39	35.39	1000.0
2008-10-06 05:00:00	QQQ	ETF	35.43	35.43	35.35	35.35	6500.0
2008-10-06 05:30:00	QQQ	ETF	35.22	35.22	35.0	35.0	3700.0
2008-10-06 06:00:00	QQQ	ETF	35.13	35.28	35.13	35.28	2700.0
2008-10-06 06:30:00	QQQ	ETF	35.37	35.49	35.37	35.38	11000.0
2008-10-06 07:00:00	QQQ	ETF	35.5	35.56	35.29	35.39	88214.0
2008-10-06 07:30:00	QQQ	ETF	35.4	35.64	35.32	35.56	143474.0
2008-10-06 08:00:00	QQQ	ETF	35.56	35.85	35.21	35.41	2356384.0
2008-10-06 08:30:00	QQQ	ETF	35.41	35.54	35.34	35.47	718471.0
2008-10-06 09:00:00	QQQ	ETF	35.51	35.71	35.24	35.29	1060824.0
2008-10-06 09:30:00	QQQ	ETF	35.26	35.44	34.51	34.68	33925058.0
2008-10-06 10:00:00	QQQ	ETF	34.68	34.821	34.13	34.2	26103532.0
2008-10-06 10:30:00	QQQ	ETF	34.1989	34.33	33.37	34.3	31225006.0
2008-10-06 11:00:00	QQQ	ETF	34.29	34.6	34.17	34.38	24953150.0
2008-10-06 11:30:00	QQQ	ETF	34.38	34.41	33.97	34.02	17401324.0
2008-10-06 12:00:00	QQQ	ETF	34.02	34.2	33.96	34.01	12652858.0
2008-10-06 12:30:00	QQQ	ETF	34.01	34.08	33.69	33.72	11019990.0

> showing 50 of 6,896 rows — these rows as CSV

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