PREVIEW / etf_30min / 2009-07-15

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-07-15.parquet
  size:    231 KB
  rows:    7,586

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
2009-07-15 04:00:00	SPY	ETF	91.39	91.39	91.39	91.39	300.0
2009-07-15 04:30:00	SPY	ETF	91.5	91.59	91.5	91.59	900.0
2009-07-15 05:00:00	SPY	ETF	91.59	91.6	91.59	91.6	2100.0
2009-07-15 05:30:00	SPY	ETF	91.65	91.67	91.62	91.67	911.0
2009-07-15 06:00:00	SPY	ETF	91.67	91.7	91.65	91.7	18349.0
2009-07-15 06:30:00	SPY	ETF	91.69	91.8	91.67	91.67	6900.0
2009-07-15 07:00:00	SPY	ETF	91.68	91.75	91.54	91.55	181224.0
2009-07-15 07:30:00	SPY	ETF	91.59	91.63	91.43	91.63	442529.0
2009-07-15 08:00:00	SPY	ETF	91.63	91.95	91.6	91.68	1114813.0
2009-07-15 08:30:00	SPY	ETF	91.7	91.9	90.63	91.74	1388652.0
2009-07-15 09:00:00	SPY	ETF	91.74	91.9	91.73	91.81	1921459.0
2009-07-15 09:30:00	SPY	ETF	91.81	92.19	91.68	92.09	21254875.0
2009-07-15 10:00:00	SPY	ETF	92.09	92.37	92.07	92.33	15382120.0
2009-07-15 10:30:00	SPY	ETF	92.32	92.4	92.15	92.24	12126855.0
2009-07-15 11:00:00	SPY	ETF	92.24	92.64	92.24	92.6	11902729.0
2009-07-15 11:30:00	SPY	ETF	92.59	92.76	92.56	92.59	10248956.0
2009-07-15 12:00:00	SPY	ETF	92.5999	92.72	92.53	92.67	7972435.0
2009-07-15 12:30:00	SPY	ETF	92.67	92.8	92.62	92.6695	7868490.0
2009-07-15 13:00:00	SPY	ETF	92.67	92.8	92.63	92.8	6238455.0
2009-07-15 13:30:00	SPY	ETF	92.8	93.0	92.77	92.9	9048268.0
2009-07-15 14:00:00	SPY	ETF	92.9099	93.11	92.77	93.0	15199924.0
2009-07-15 14:30:00	SPY	ETF	93.01	93.38	93.0	93.35	18078335.0
2009-07-15 15:00:00	SPY	ETF	93.3501	93.51	93.14	93.16	17787300.0
2009-07-15 15:30:00	SPY	ETF	93.15	93.48	93.03	93.33	34224292.0
2009-07-15 16:00:00	SPY	ETF	93.32	93.4319	92.28	93.12	8628328.0
2009-07-15 16:30:00	SPY	ETF	93.12	93.4069	92.75	93.1	1609648.0
2009-07-15 17:00:00	SPY	ETF	93.11	93.23	93.11	93.17	404650.0
2009-07-15 17:30:00	SPY	ETF	93.17	93.22	93.16	93.19	145931.0
2009-07-15 18:00:00	SPY	ETF	93.18	93.19	92.84	92.85	542967.0
2009-07-15 18:30:00	SPY	ETF	92.87	92.99	92.82	92.91	309433.0
2009-07-15 19:00:00	SPY	ETF	92.88	92.88	92.79	92.8	81073.0
2009-07-15 19:30:00	SPY	ETF	92.78	92.96	92.76	92.9	40458.0
2009-07-15 04:30:00	QQQ	ETF	36.28	36.28	36.28	36.28	100.0
2009-07-15 06:00:00	QQQ	ETF	36.32	36.32	36.32	36.32	100.0
2009-07-15 06:30:00	QQQ	ETF	36.3	36.35	36.3	36.3	2400.0
2009-07-15 07:00:00	QQQ	ETF	36.29	36.32	36.23	36.25	168100.0
2009-07-15 07:30:00	QQQ	ETF	36.25	36.25	36.18	36.25	245082.0
2009-07-15 08:00:00	QQQ	ETF	36.26	36.4	36.24	36.24	428686.0
2009-07-15 08:30:00	QQQ	ETF	36.24	36.29	36.23	36.26	325735.0
2009-07-15 09:00:00	QQQ	ETF	36.26	36.32	36.25	36.31	1407391.0
2009-07-15 09:30:00	QQQ	ETF	36.31	36.55	36.14	36.41	33903610.0
2009-07-15 10:00:00	QQQ	ETF	36.41	36.61	36.41	36.6	13316923.0
2009-07-15 10:30:00	QQQ	ETF	36.6	36.61	36.54	36.57	6838763.0
2009-07-15 11:00:00	QQQ	ETF	36.57	36.74	36.57	36.7	9620893.0
2009-07-15 11:30:00	QQQ	ETF	36.7	36.73	36.63	36.651	12134082.0
2009-07-15 12:00:00	QQQ	ETF	36.66	36.71	36.64	36.69	5193391.0
2009-07-15 12:30:00	QQQ	ETF	36.69	36.73	36.65	36.68	4899549.0
2009-07-15 13:00:00	QQQ	ETF	36.68	36.72	36.64	36.71	4327965.0
2009-07-15 13:30:00	QQQ	ETF	36.715	36.81	36.7	36.77	5972897.0
2009-07-15 14:00:00	QQQ	ETF	36.76	36.81	36.72	36.76	7679917.0

> showing 50 of 7,586 rows — these rows as CSV

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