PREVIEW / etf_30min / 2009-03-12

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-03-12.parquet
  size:    213 KB
  rows:    6,982

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-03-12 04:00:00	SPY	ETF	72.3	72.47	72.28	72.4	4000.0
2009-03-12 04:30:00	SPY	ETF	72.0	72.0	71.98	72.0	3500.0
2009-03-12 05:30:00	SPY	ETF	72.07	72.07	72.06	72.06	6000.0
2009-03-12 06:00:00	SPY	ETF	71.9	71.9	71.7	71.81	14600.0
2009-03-12 06:30:00	SPY	ETF	71.75	71.89	71.75	71.81	80550.0
2009-03-12 07:00:00	SPY	ETF	71.82	71.95	71.72	71.95	206674.0
2009-03-12 07:30:00	SPY	ETF	71.93	72.09	71.89	72.06	427645.0
2009-03-12 08:00:00	SPY	ETF	72.06	72.41	71.86	72.28	1938425.0
2009-03-12 08:30:00	SPY	ETF	72.27	72.68	72.21	72.5	3872927.0
2009-03-12 09:00:00	SPY	ETF	72.49	72.8	72.01	72.62	7259071.0
2009-03-12 09:30:00	SPY	ETF	72.62	72.81	71.97	72.51	35353455.0
2009-03-12 10:00:00	SPY	ETF	72.51	73.595	72.48	73.37	40120612.0
2009-03-12 10:30:00	SPY	ETF	73.38	74.02	73.2	73.72	27960911.0
2009-03-12 11:00:00	SPY	ETF	73.72	73.87	73.37	73.43	25435528.0
2009-03-12 11:30:00	SPY	ETF	73.42	73.92	73.33	73.6901	16829826.0
2009-03-12 12:00:00	SPY	ETF	73.7	74.12	73.68	73.85	21295123.0
2009-03-12 12:30:00	SPY	ETF	73.84	74.41	73.77	74.37	21131073.0
2009-03-12 13:00:00	SPY	ETF	74.37	74.48	74.1	74.17	21125376.0
2009-03-12 13:30:00	SPY	ETF	74.17	74.58	74.11	74.4525	16764195.0
2009-03-12 14:00:00	SPY	ETF	74.44	74.98	74.26	74.83	29754930.0
2009-03-12 14:30:00	SPY	ETF	74.82	75.29	72.95	75.04	26395129.0
2009-03-12 15:00:00	SPY	ETF	75.0301	75.31	72.6444	75.16	25602276.0
2009-03-12 15:30:00	SPY	ETF	75.16	75.75	75.08	75.51	50615225.0
2009-03-12 16:00:00	SPY	ETF	75.51	75.8	73.5365	75.59	13800717.0
2009-03-12 16:30:00	SPY	ETF	75.59	75.66	75.46	75.51	9778715.0
2009-03-12 17:00:00	SPY	ETF	75.51	75.55	72.6445	75.49	11284814.0
2009-03-12 17:30:00	SPY	ETF	75.49	75.57	75.41	75.47	104378.0
2009-03-12 18:00:00	SPY	ETF	75.49	75.5	75.4	75.41	91827.0
2009-03-12 18:30:00	SPY	ETF	75.42	75.45	75.39	75.4	28348.0
2009-03-12 19:00:00	SPY	ETF	75.42	75.45	75.37	75.45	22469.0
2009-03-12 19:30:00	SPY	ETF	75.41	75.48	75.38	75.48	51623.0
2009-03-12 04:00:00	QQQ	ETF	27.66	27.69	27.62	27.62	3685.0
2009-03-12 04:30:00	QQQ	ETF	27.57	27.57	27.49	27.49	2835.0
2009-03-12 05:30:00	QQQ	ETF	27.55	27.55	27.54	27.54	324.0
2009-03-12 06:00:00	QQQ	ETF	27.51	27.51	27.51	27.51	300.0
2009-03-12 06:30:00	QQQ	ETF	27.47	27.5	27.44	27.5	2600.0
2009-03-12 07:00:00	QQQ	ETF	27.46	27.46	27.41	27.44	41400.0
2009-03-12 07:30:00	QQQ	ETF	27.5	27.5	27.45	27.49	19600.0
2009-03-12 08:00:00	QQQ	ETF	27.49	27.59	27.47	27.54	218616.0
2009-03-12 08:30:00	QQQ	ETF	27.54	27.72	27.53	27.67	520890.0
2009-03-12 09:00:00	QQQ	ETF	27.67	27.77	27.53	27.73	1152831.0
2009-03-12 09:30:00	QQQ	ETF	27.72	27.77	27.44	27.59	19249390.0
2009-03-12 10:00:00	QQQ	ETF	27.6	27.98	27.58	27.89	16734408.0
2009-03-12 10:30:00	QQQ	ETF	27.89	28.11	27.83	28.04	7573269.0
2009-03-12 11:00:00	QQQ	ETF	28.03	28.08	27.89	27.9301	9632249.0
2009-03-12 11:30:00	QQQ	ETF	27.94	28.2	27.901	28.1398	9572361.0
2009-03-12 12:00:00	QQQ	ETF	28.14	28.24	28.12	28.1701	7655164.0
2009-03-12 12:30:00	QQQ	ETF	28.17	28.35	28.14	28.32	6209053.0
2009-03-12 13:00:00	QQQ	ETF	28.32	28.37	28.24	28.27	9921384.0
2009-03-12 13:30:00	QQQ	ETF	28.27	28.38	28.24	28.3017	7199777.0

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

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